#
# fusion.db.util
#
# Copyright 2006-2007 Helsinki Institute for Information Technology
# and the authors.
#
# Authors: Ken Rimey <rimey@hiit.fi>
#

# Permission is hereby granted, free of charge, to any person
# obtaining a copy of this software and associated documentation files
# (the "Software"), to deal in the Software without restriction,
# including without limitation the rights to use, copy, modify, merge,
# publish, distribute, sublicense, and/or sell copies of the Software,
# and to permit persons to whom the Software is furnished to do so,
# subject to the following conditions:
#
# The above copyright notice and this permission notice shall be
# included in all copies or substantial portions of the Software.
#
# THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
# EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
# MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
# IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY
# CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT,
# TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE
# SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

"""
Utilies for db.py

Having a separate module for this stuff lets you import it without
importing db.py.  This can be helpful in avoiding circular imports.
"""

import sys

def get_default_path():
    if sys.platform == 'win32':
        return '~/.fusion/fusion.db'
    else:
        return '~/.fusion/fusion.db'

def no_such_table(exception):
    """
    Determine whether an instance of SQLError is signalling "no such table".
    """
    return 'no such table' in str(exception)

def get_single_row(cursor):
    for row in list(cursor):
        return row
    raise LookupError

def get_single_value(cursor):
    for v, in list(cursor):
        return v
    raise LookupError

def get_values(cursor):
    return [v for v, in cursor]
